Hi,
Excel returns "Data not available"
when the parameter value is specified as a range of cells
Wireshark shows that the query uses plus signs as separators rather than commas
9 3.725510000 192.168.0.2 204.79.197.203 HTTP 1907 GET /en-us/money/quoteslookup?SYMBOL=MSFT+AAPL+IBM HTTP/1.1
The URL for the request is
http://www.msn.com/en-us/money/quoteslookup?SYMBOL=MSFT+AAPL+IBM
Below is information about what already works.
Excel returns the requested data when the parameter value is specified as a comma-separated list.
In this case Wireshark shows that the query uses commas as separators
9 4.625964000 192.168.0.2 204.79.197.203 HTTP 1907 GET /en-us/money/quoteslookup?SYMBOL=MSFT,AAPL,IBM HTTP/1.1
The URL for the request is
http://www.msn.com/en-us/money/quoteslookup?SYMBOL=MSFT,AAPL,IBM
It should be possible to specify the parameter list as either a comma-separated list or as a range of cells. Please make it possible to specify the parameter values as a range of cells.
Thanks,
Norman